San Diego Burrito Analytics: Best and worst burritos

Default imports


In [1]:
%config InlineBackend.figure_format = 'retina'
%matplotlib inline

import numpy as np
import scipy as sp
import matplotlib.pyplot as plt
import pandas as pd

import seaborn as sns
sns.set_style("white")

Load data


In [2]:
import util
df = util.load_burritos()
N = df.shape[0]
df.head()


Out[2]:
Location Burrito Date Neighborhood Address URL Yelp Google Chips Cost ... Nopales Lobster Queso Egg Mushroom Bacon Sushi Avocado Corn Zucchini
0 donato's taco shop California 1/18/2016 Miramar 6780 Miramar Rd http://donatostacoshop.net/ 3.5 4.2 None 6.49 ... None None None None None None None None None None
1 oscar's mexican food California 1/24/2016 San Marcos 225 S Rancho Santa Fe Rd http://www.yelp.com/biz/oscars-mexican-food-sa... 3.5 3.3 None 5.45 ... None None None None None None None None None None
2 oscar's mexican food Carnitas 1/24/2016 None None None NaN NaN None 4.85 ... None None None None None None None None None None
3 oscar's mexican food Carne asada 1/24/2016 None None None NaN NaN None 5.25 ... None None None None None None None None None None
4 pollos maria California 1/27/2016 Carlsbad 3055 Harding St http://pollosmaria.com/ 4.0 3.8 x 6.59 ... None None None None None None None None None None

5 rows × 65 columns

Worst burritos


In [5]:
df.loc[33]


Out[5]:
Location                 raul's mexican food
Burrito                          carne asada
Date                               3/11/2016
Neighborhood                            None
Address                                 None
URL                                     None
Yelp                                     NaN
Google                                   NaN
Chips                                   None
Cost                                       5
Hunger                                     1
Mass (g)                                 NaN
Length                                   NaN
Circum                                   NaN
Volume                                   NaN
Tortilla                                   2
Temp                                     NaN
Meat                                       1
Fillings                                   1
Meat:filling                             0.5
Uniformity                                 1
Salsa                                    1.5
Synergy                                    1
Wrap                                       4
overall                                    1
Rec                                     None
Reviewer                               Scott
Notes            burrito was mostly tortilla
Unreliable                                 0
NonSD                                      0
                            ...             
Sour cream                              None
Pork                                    None
Chicken                                 None
Shrimp                                  None
Fish                                    None
Rice                                    None
Beans                                   None
Lettuce                                 None
Tomato                                  None
Bell peper                              None
Carrots                                 None
Cabbage                                 None
Sauce                                   None
Salsa.1                                 None
Cilantro                                None
Onion                                   None
Taquito                                 None
Pineapple                               None
Ham                                     None
Chile relleno                           None
Nopales                                 None
Lobster                                 None
Queso                                   None
Egg                                     None
Mushroom                                None
Bacon                                   None
Sushi                                   None
Avocado                                 None
Corn                                    None
Zucchini                                None
Name: 33, dtype: object

In [4]:
df.sort_values('overall')[['Location','Burrito','overall']]


Out[4]:
Location Burrito overall
33 raul's mexican food carne asada 1.0
101 roberto's very mexican food Chicken asada 1.5
71 senor grubby's California 1.5
187 lucha libre north park Holy Moly 1.5
97 goody's Custom 1.8
72 senor grubby's Pastor 1.8
146 los primos mexican food Carne asada 2.0
32 raul's mexican food Chile verde pork 2.0
178 lucha libre north park Bean and cheese 2.0
116 los primos mexican food Carnitas 2.0
275 lupe's taco shop Spicy a la Diabla 2.0
263 gloria's taco shop Cabeza 2.0
233 taco villa Bean & cheese 2.0
164 lucha libre north park Surf & Turf 2.0
9 jv's mexican food Carne Asada 2.0
13 tony's fresh mexican food battered fish 2.0
113 los primos mexican food California breakfast 2.0
189 lucha libre north park Holy Moly 2.0
114 los primos mexican food Baja monster 2.0
166 lucha libre north park Surf & Turf 2.2
147 papa chito's mexican food California 2.2
224 california burrito company Fajitas 2.2
124 lolita's taco shop California 2.3
111 los primos mexican food Monster California 2.3
165 lucha libre north park Surf & Turf 2.4
184 lucha libre north park California - Chicken 2.5
10 jv's mexican food Surf & Turf 2.5
88 rigoberto's taco shop El Rusio 2.5
51 la perla cocina Addiction 2.5
144 los primos mexican food Surf & Turf 2.5
... ... ... ...
62 taco stand Carne asada 4.4
175 lucha libre north park Nutty 4.4
257 los panchos taco shop Bitchin California 4.4
98 taco surf pb California 4.4
176 lucha libre north park Veg Out 4.5
292 california burritos California everything mini 4.5
254 cancun mexican & seafood California 4.5
24 taco stand California 4.5
79 taco stand California 4.5
198 taco stand Al Pastor 4.5
57 rigoberto's taco shop Adobada 4.5
56 rigoberto's taco shop California 4.5
251 valentines mexican food California 4.5
132 california burritos California Everything 4.5
131 california burritos California Everything 4.5
255 cancun mexican & seafood California 4.5
133 california burritos Carnitas 4.5
50 mikes taco club California 4.5
135 california burritos Carne asada everything 4.5
183 lucha libre north park California - Pork Adobada 4.5
295 california burritos Surf & Turf 4.5
23 taco stand California 4.6
66 california burritos California Everything 4.6
199 taco stand California 4.7
253 valentines mexican food California 4.7
73 taco stand California 4.9
250 valentines mexican food Pork california 5.0
228 california burritos Surf & Turf 5.0
141 california burritos California Everything NaN
142 california burritos Surf & Turf NaN

296 rows × 3 columns


In [ ]: